
--------------------------------------------------------------------
--Nombre:	SP_ActualizarOrdeTrabMaterial
--Objetivo: Actualizar registros a la tabla OrdeTrabMaterial
--Creacion    : TISI(GOS) 20130226
--------------------------------------------------------------------
CREATE PROCEDURE SP_ActualizarOrdeTrabMaterial
(

  @IDOt bigint,
  @IDMaterial bigint,
  @CantMatOt decimal,
  @CostoMatOt decimal
)
AS
BEGIN
  UPDATE OrdeTrabMaterial
  SET
  IDOt = @IDOt,
    IDMaterial = @IDMaterial,
    CantMatOt = @CantMatOt,
    CostoMatOt = @CostoMatOt   
 WHERE
 IDOt = @IDOt
     AND
   IDMaterial = @IDMaterial
END
GO
  